Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
WorkstationID (FK)(PK) | The unique identifier for the WORKSTATION, typically the serial number. | ID_WS | Identity | integer | Workstation(AS_WS) |
WorkstationRuleTypeCode (FK)(PK) | A code that refers to a specific WORKSTATION RULE type. | TY_RU_WS | Code2 | char(2) | WorkstationRule(RU_WS) |
WorkstationRuleNumber (FK)(PK) | A reference number for a specific WORKSTATION RULE. | ID_RU_WS | Identity | integer | WorkstationRule(RU_WS) |
WorkstationGroupID (FK)(PK) | A unique identifier for a group of WORKSTATIONs. This could refer to the WORKSTATIONs at the checkout, delicatessen, customer service or in the goods receiving area of the store. | ID_GP_WS | Identity | integer | WorkstationRule(RU_WS) |
EffectiveDate | The date on which a specific WORKSTATION RULE becomes effective. | DC_APLN_EF | EffectiveDateTime | datetime | |
ExpirationDate | The date on which a specific WORKSTATION RULE expires. | DC_APLN_EP | ExpirationDateTime | datetime | |
CreateDateTimestamp | The time and date on which a specific WORKSTATION RULE is created. | TS_APLN_CRT | AuditDateTime | datetime | |